package world.liquor.dao;

import java.sql.SQLException;
import java.util.ArrayList;

import world.liquor.domain.BeerAssessment;

public interface BeerAssessmentDAO {
	public void insertBeerAssessment(BeerAssessment assess) throws SQLException;
	public int deleteBeerAssessment(int beer_assessment_id) throws SQLException;
	public int updateBeerAssessment(BeerAssessment assessment) throws SQLException;
	public BeerAssessment selectBeerAssessmentById(int beer_assessment_id) throws SQLException;
	public BeerAssessment selectBeerAssessmentByMemberAndBeerId(String member_id, String beer_info_id) throws SQLException;
	public ArrayList<BeerAssessment> selectBeerAssessmentByMemberId(String member_id) throws SQLException;
	public ArrayList<BeerAssessment> selectBeerAssessmentByBeerInfoId(String beer_info_id) throws SQLException;
	public ArrayList<BeerAssessment> selectBeerAssessmentByAssessment(int assessment) throws SQLException;
	public ArrayList<BeerAssessment> selectAllBeerAssessment() throws SQLException;
	
}
